package com.njitt.bysj.mapper;

import com.njitt.bysj.base.BaseMapper;
import com.njitt.bysj.bean.MaterialBean;
import org.apache.ibatis.annotations.MapKey;

import java.util.List;
import java.util.Map;

/**
 * @description: 物料
 * @return: * @param null
 * @author:
 * @time: 2022/4/13 15:46
 */
public interface MaterialBeanMapper extends BaseMapper<MaterialBean, Integer> {
    @MapKey("id")
    List<Map<String, Object>> queryMainMaterialInSupplier(Integer supplierId);

    MaterialBean selectByMaterialNo(String materialNo);

    @MapKey("id")
    List<Map<String, Object>> queryAllMaterialBySelected();

    @MapKey("no")
    List<Map<String, Object>> selectMaterialBySupplerIdToAddPurchaseOrder(Integer supplierId);

    String selectMaterialNameByMaterialIdToAddPurchaseOrder(String materialNo);
}